<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <meta name="viewport" content="maximum-scale=1.0,minimum-scale=1.0,user-scalable=no,width=device-width,initial-scale=1.0"/>

  <title>e网批发管理后台</title>
  <?php include("common/conn.php"); if($_SESSION['userid']==""){echo "<script>window.location.href='login.php';</script>";} 

  if($_GET['del']=="ok")
  {
    $area = array(); 
    $area= $_POST['checkbox'];

    foreach ($area as $k=>$v)
    {
      $srat1=mysql_query("DELETE FROM coupon where couponid='".$v."'");
    }

  }

  ?>
  <script type="text/javascript" src="js/jquery.min.js"></script>
  <link href="css/styles.css" rel="stylesheet" type="text/css" />
  <link href="css/style2.css" rel="stylesheet" type="text/css" />    
  <script type="text/JavaScript">
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
</script>
</head>

<body>
  <!-- header -->
  <?php include("common/header.php"); ?>
  <!-- header end -->
  <div id="sub_nav">

    <div id="subnav_wrap" class="container_12">
      <div id="subnav" class=" grid_12">

      </div>

    </div>


  </div>
  <div class="container_12" >
    <form action="?" method="post">
      <input class="text" type="text" placeholder="搜索优惠券关键字"  name="keywords"/>

      <input name="" type="submit" value="搜索优惠券" class="submit"/>
      <input type="button" class="submit" value="新增优惠券" onclick="add();">
    </form>
  </div>
  <form action="?del=ok" method="post">

    <div class="container_12">

      <table width="100%" border="0" cellpadding="0" cellspacing="0">



        <tr>

          <th width="5%" scope="col">
            <input type="checkbox" name="checkbox" id="checkbox" class="checkall" /><label for="checkbox"></label>
          </th>
          <th width="18%" scope="col">图	</th>
          <th width="13%" scope="col">标题</th>
          <th width="13%" scope="col">剩余数量</th>
          <th width="13%" scope="col">满多少</th>
          <th width="13%" scope="col">送多少</th>
          <th width="13%" scope="col">截止时间</th>
          <th width="13%" scope="col">操作</th>
        </tr>

        <?php 
mysql_query('SET NAMES UTF8');  

$ren="1";
$sex="0";
$perNumber=20; //每页显示的记录数
$page=$_GET['page']; //获得当前的页面值
if($_REQUEST[keywords]!="")
{
  $count=mysql_query("select count(*) from coupon where title like '%".$_REQUEST[keywords]."%' and shopid=0");

}

else
{
  $count=mysql_query("select count(*) from coupon where shopid=0");
}

//获得记录总数
$rs=mysql_fetch_array($count); 
$totalNumber=$rs[0];
$totalPage=ceil($totalNumber/$perNumber); //计算出总页数

if (!isset($page)) {
  $page=1;
} //如果没有值,则赋值1
$startCount=($page-1)*$perNumber; //分页开始,根据此方法计算出开始的

if($_REQUEST[keywords]!="")
{
  $rert30=mysql_query("select * from coupon where title like '%".$_REQUEST[keywords]."%' and shopid=0 order by couponid desc limit $startCount,$perNumber");
}	



else {
  $rert30=mysql_query("select * from coupon where shopid=0 order by couponid desc limit $startCount,$perNumber");
}				


while($sdg30=mysql_fetch_array($rert30)){


  $rert31=mysql_query("select * from goods where goodsid='".$sdg30[goodsid]."'");
  $sdg31=mysql_fetch_array($rert31);

  ?>

  <tr>

    <td scope="col"><input type="checkbox" name="checkbox[]" id="checkbox"  value="<?php echo $sdg30[couponid];?>"/></td>
    <td scope="col"><img src="<?php echo $sdg30[images];?>"  height="50" width="50"/></td>
    <td scope="col"><?php echo $sdg30[title];?></td>
    <td scope="col"><?php echo $sdg30[number];?></td>
    <td scope="col"><?php echo $sdg30[top_price];?></td>
    <td scope="col"><?php echo $sdg30[price];?></td>
    <td scope="col"><?php echo $sdg30[enddate];?></td>
    <td scope="col"><a href="addyouhui.php?id=<?php echo $sdg30[couponid];?>">编辑优惠券</a></td>
  </tr>


  <?php }?>
</table>

<!-- END TABULAR DATA EXAMPLE -->



<div class="grid_12">

  <div class="clearfix"><input name="" type="submit" value="删除所选" class="submit"/></div>

  <ul id="pagination">



    <?php  

    if ($page > 1) { //上一页 ?>
    <li><a     href="?page=1&keywords=<?php echo $_REQUEST[keywords]; ?>&classify=<?php echo $_REQUEST[classify]; ?>">首页</a></li>
    <li><a     href="?page=<?php echo ($page-1); ?>&keywords=<?php echo $_REQUEST[keywords]; ?>&classify=<?php echo $_REQUEST[classify]; ?>">上一页</a></li>
    <?php }

    ?>

    <li class="active"><?php echo $page;?></li>

    <?php



    if ($_GET[page]!=$totalPage) { //下一页 ?>
    <li><a     href="?page=<?php echo ($page+1); ?>&keywords=<?php echo $_REQUEST[keywords]; ?>&classify=<?php echo $_REQUEST[classify]; ?>">下一页</a></li>
    <?php }

    if ($totalPage>1) { //下一页 ?>
    <li><a     href="?page=<?php echo $totalPage; ?>&keywords=<?php echo $_REQUEST[keywords]; ?>&classify=<?php echo $_REQUEST[classify]; ?>">尾页</a></li>

    <?php }?>


  </ul>

</div>           
</div>


</form>
</body>
<script type="text/javascript">
  function add(){
    window.location.href="addyouhui.php";
  }
</script>
</html>
